/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 90100
 Source Host           : localhost:3306
 Source Schema         : face_attendance

 Target Server Type    : MySQL
 Target Server Version : 90100
 File Encoding         : 65001

 Date: 30/07/2025 00:11:32
*/
#
# SET NAMES utf8mb4;
# SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` int NOT NULL COMMENT '1:管理员, 2:安全员',
  `wc_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '公众号OpenId',
  `app_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '小程序OpenId',
  `union_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '联盟Id',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '昵称',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '头像',
  `class_id` bigint DEFAULT NULL,
  `on_duty` int NOT NULL COMMENT '0不在岗1在岗',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of admin_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_users` VALUES (19, 'systemadmin', '$2a$10$U2QMp/pza8PkCi36bRhzE.hK3sk0gMJmmjHeegU9aasCx0OC.Meza', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `admin_users` VALUES (20, 'zyj', '$2a$10$/NF6yOoPdHVqnTOCFe4IW.GlNYLsh9gvXAWv7Z08vbOZy6lqIS0Z2', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `admin_users` VALUES (21, 'test', '$2a$10$3.r/jqfq55HJ7k6/REQdVuEiF2koXio84HHQBBbxTUVfTYFzJ8gha', 2, NULL, NULL, NULL, NULL, NULL, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for attendance_records
-- ----------------------------
DROP TABLE IF EXISTS `attendance_records`;
CREATE TABLE `attendance_records` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `white_list_id` bigint NOT NULL,
  `entry_time` datetime NOT NULL COMMENT '进场时间',
  `exit_time` datetime DEFAULT NULL COMMENT '出场时间',
  `status` int NOT NULL COMMENT '进出状态：0(进入), 1(离开)',
  `area` varchar(255) DEFAULT NULL,
  `is_entered` tinyint(1) DEFAULT NULL COMMENT '是否进入状态',
  `stay_duration` bigint DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注信息(如请假原因等)',
  `device_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '考勤设备ID',
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '人脸识别图片存储路径',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`white_list_id`),
  KEY `idx_entry_time` (`entry_time`),
  KEY `idx_status` (`status`),
  CONSTRAINT `FK4vyatgt518eyil5f3w1mq65qb` FOREIGN KEY (`white_list_id`) REFERENCES `white_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of attendance_records
-- ----------------------------
BEGIN;
INSERT INTO `attendance_records` VALUES (1, 1, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 30733000, '39.9042,116.4074', '正常考勤', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (2, 3, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心B区', 1, 30427000, '39.9042,116.4074', '', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (3, 4, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 31037000, '39.9042,116.4074', '带笔记本电脑', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (4, 5, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30346000, '39.9042,116.4074', '', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (5, 6, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心B区', 0, 30293000, '39.9042,116.4074', '迟到', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (6, 7, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 30214000, '39.9042,116.4074', '早退', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (7, 8, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30914000, '39.9042,116.4074', '', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (8, 9, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心B区', 1, 30637000, '39.9042,116.4074', '', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (9, 10, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心A区', 0, 30526000, '39.9042,116.4074', '', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (10, 11, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30621000, '39.9042,116.4074', '正常考勤', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (11, 1, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 30733000, '39.9042,116.4074', '正常考勤', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (12, 3, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心B区', 1, 30427000, '39.9042,116.4074', '', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (13, 4, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 31037000, '39.9042,116.4074', '带笔记本电脑', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (14, 5, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30346000, '39.9042,116.4074', '', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (15, 6, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心B区', 0, 30293000, '39.9042,116.4074', '迟到', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (16, 7, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心A区', 1, 30214000, '39.9042,116.4074', '早退', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (17, 8, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30914000, '39.9042,116.4074', '', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (18, 9, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 0, '学习中心B区', 1, 30637000, '39.9042,116.4074', '', 'DEV002', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (19, 10, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心A区', 0, 30526000, '39.9042,116.4074', '', 'DEV001', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
INSERT INTO `attendance_records` VALUES (20, 11, '2025-07-28 03:25:15', '2025-07-28 23:25:15', 1, '学习中心C区', 0, 30621000, '39.9042,116.4074', '正常考勤', 'DEV003', 'd099e757-be50-415d-8ce1-c14aedb302a4.jpg');
COMMIT;

-- ----------------------------
-- Table structure for push_message
-- ----------------------------
DROP TABLE IF EXISTS `push_message`;
CREATE TABLE `push_message` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `whitelist_id` bigint DEFAULT NULL,
  `type` int NOT NULL COMMENT '消息类型: 1-异常考勤, 2-警报',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '相关图片路径',
  `create_time` datetime NOT NULL COMMENT '消息创建时间',
  `push_status` int NOT NULL COMMENT '0:待处理, 1:已处理',
  `handler_id` bigint DEFAULT NULL COMMENT '处理人ID',
  `handle_time` datetime DEFAULT NULL COMMENT '处理时间',
  `enter_status` int DEFAULT NULL COMMENT '1进入/2离开',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`whitelist_id`),
  KEY `idx_create_time` (`create_time`),
  CONSTRAINT `FK356p6wb9qhp56m7ehn0prrwr5` FOREIGN KEY (`whitelist_id`) REFERENCES `white_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of push_message
-- ----------------------------
BEGIN;
INSERT INTO `push_message` VALUES (1, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 1, '2025-07-25 16:41:32', 1);
INSERT INTO `push_message` VALUES (2, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 1, '2025-07-25 17:05:57', 1);
INSERT INTO `push_message` VALUES (3, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 1, '2025-07-25 17:06:34', 1);
INSERT INTO `push_message` VALUES (4, 4, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-04 19:00:00', 1);
INSERT INTO `push_message` VALUES (5, 5, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-05 10:30:00', 1);
INSERT INTO `push_message` VALUES (6, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-06 12:30:00', 1);
INSERT INTO `push_message` VALUES (7, NULL, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 1, '2025-07-28 09:26:35', 1);
INSERT INTO `push_message` VALUES (8, 3, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-09 08:00:00', 1);
INSERT INTO `push_message` VALUES (9, 6, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-09 11:00:00', 1);
INSERT INTO `push_message` VALUES (10, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 1);
INSERT INTO `push_message` VALUES (11, 5, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-11 16:45:00', 2);
INSERT INTO `push_message` VALUES (12, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 1, '2025-07-28 09:17:42', 2);
INSERT INTO `push_message` VALUES (13, NULL, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 2);
INSERT INTO `push_message` VALUES (14, 4, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-15 18:00:00', 2);
INSERT INTO `push_message` VALUES (15, 5, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2025-07-23 20:12:39', 1);
INSERT INTO `push_message` VALUES (16, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-17 10:15:00', 2);
INSERT INTO `push_message` VALUES (17, 9, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2025-07-23 12:07:40', 2);
INSERT INTO `push_message` VALUES (18, 12, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-19 15:30:00', 1);
INSERT INTO `push_message` VALUES (19, 10, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-13 11:30:00', 2);
INSERT INTO `push_message` VALUES (20, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-01 10:00:00', 2);
INSERT INTO `push_message` VALUES (21, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 2);
INSERT INTO `push_message` VALUES (22, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 2);
INSERT INTO `push_message` VALUES (23, 4, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-04 19:00:00', 2);
INSERT INTO `push_message` VALUES (24, 5, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-05 10:30:00', 2);
INSERT INTO `push_message` VALUES (25, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-06 12:30:00', 1);
INSERT INTO `push_message` VALUES (26, NULL, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 1);
INSERT INTO `push_message` VALUES (27, 3, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-09 08:00:00', 1);
INSERT INTO `push_message` VALUES (28, 6, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-09 11:00:00', 1);
INSERT INTO `push_message` VALUES (29, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 0, NULL, NULL, 2);
INSERT INTO `push_message` VALUES (30, 5, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-11 16:45:00', 1);
INSERT INTO `push_message` VALUES (31, NULL, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 53, '2025-07-29 18:09:13', 2);
INSERT INTO `push_message` VALUES (32, NULL, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 53, '2025-07-29 18:09:00', 1);
INSERT INTO `push_message` VALUES (33, 4, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-15 18:00:00', 2);
INSERT INTO `push_message` VALUES (34, 5, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2025-07-23 20:12:39', 1);
INSERT INTO `push_message` VALUES (35, 1, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-17 10:15:00', 2);
INSERT INTO `push_message` VALUES (36, 9, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2025-07-23 12:07:40', 1);
INSERT INTO `push_message` VALUES (37, 12, 2, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-19 15:30:00', 1);
INSERT INTO `push_message` VALUES (38, 10, 1, '校门口', 'd3e614f8-211e-4a80-a5ed-aed3e6bcd622.jpg', '2025-07-28 13:25:15', 1, 3, '2024-03-13 11:30:00', 1);
COMMIT;

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `jwt_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'JWT加密密钥',
  `jwt_expiration_ms` bigint NOT NULL COMMENT 'JWT过期时间(毫秒)',
  `wechat_app_id` varchar(255) DEFAULT NULL COMMENT '微信应用ID',
  `wechat_app_secret` varchar(255) DEFAULT NULL COMMENT '微信应用密钥',
  `uni_app_id` varchar(255) DEFAULT NULL COMMENT '小程序APPID',
  `uni_app_secret` varchar(255) DEFAULT NULL COMMENT '小程序密钥',
  `wechat_template_id` varchar(255) DEFAULT NULL COMMENT '微信消息模板ID',
  `wechat_access_token` text COMMENT '微信访问令牌',
  `message_detail_url` varchar(255) DEFAULT NULL COMMENT '跳转地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统配置表';

-- ----------------------------
-- Records of system_config
-- ----------------------------
BEGIN;
INSERT INTO `system_config` VALUES (1, 's9k/LwzZ4mDfW2qj+5Kt6v7y8B1nC0pXeRgHlMqNrA=', 86400000, 'wxfbfc8868adbbd63e\n\n', 'd59d7790716c7305c88a39ecc29d09ec\n', 'wx4918a2d08f5abe4f\n', '3781edbb47d43f78fc54680feb2fe51e', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for system_log
-- ----------------------------
DROP TABLE IF EXISTS `system_log`;
CREATE TABLE `system_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `log_time` datetime NOT NULL,
  `log_level` varchar(10) NOT NULL,
  `logger_name` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `thread_name` varchar(50) DEFAULT NULL,
  `exception` text,
  `user_id` varchar(32) DEFAULT NULL,
  `app_name` varchar(50) DEFAULT 'attendance-system',
  `module_name` varchar(50) DEFAULT NULL,
  `method` varchar(100) DEFAULT NULL,
  `params` text,
  `ip_address` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1930 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of system_log
-- ----------------------------


-- ----------------------------
-- Table structure for white_list
-- ----------------------------
DROP TABLE IF EXISTS `white_list`;
CREATE TABLE `white_list` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '真实姓名',
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '性别',
  `birth_date` date NOT NULL COMMENT '生日',
  `role` int NOT NULL COMMENT '1:教师, 2:学生',
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '人脸图片存储路径',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已删除标记',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of white_list
-- ----------------------------
BEGIN;
INSERT INTO `white_list` VALUES (1, '王伟', '男', '1990-05-15', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 1);
INSERT INTO `white_list` VALUES (2, '李娜3', '男', '1986-08-31', 1, 'c8105ace-872f-426e-8fa1-293061f38ce0.png', '2025-07-23 15:57:47', '2025-07-28 11:06:20', 0);
INSERT INTO `white_list` VALUES (3, '张强1', '男', '1995-11-08', 1, '588b2610-9ce5-4d23-8674-dde452e6be95.png', '2025-07-23 15:57:47', '2025-07-28 11:06:47', 0);
INSERT INTO `white_list` VALUES (4, '陈晓1', '女', '2000-03-25', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', '2025-07-28 11:08:18', 0);
INSERT INTO `white_list` VALUES (5, '黄斌', '男', '1988-07-19', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (6, '周敏', '女', '1992-09-14', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 1);
INSERT INTO `white_list` VALUES (7, '吴昊', '男', '1998-01-30', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (8, '徐丽', '女', '1983-12-05', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (9, '孙浩', '男', '1993-06-17', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (10, '杨雪', '女', '1997-04-11', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (11, '朱涛', '男', '1987-10-23', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (12, '秦芳', '女', '1991-02-28', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (13, '曹阳', '男', '1999-08-09', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (14, '金燕', '女', '1986-05-12', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (15, '魏杰', '男', '1994-07-21', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (16, '谢梅', '女', '2002-01-15', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (17, '潘勇', '男', '1989-09-03', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (18, '董萍', '女', '1996-12-19', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (19, '钟磊', '男', '1984-04-27', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (20, '田静', '女', '2003-06-08', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (21, '江超', '男', '1990-10-11', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (22, '袁媛', '女', '1987-03-30', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (23, '崔健', '男', '1998-07-22', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (24, '邓敏', '女', '1993-11-14', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (25, '彭涛', '男', '1985-02-05', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (26, '陆雪', '女', '2001-09-17', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (27, '孔辉', '男', '1996-04-03', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (28, '毛丽', '女', '1989-08-28', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (29, '邱阳', '男', '1994-12-12', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (30, '史敏1', '女', '1997-01-25', 2, '47e4420c-15f6-4f00-98e6-0bf9d34001ca.png', '2025-07-23 15:57:47', '2025-07-28 11:07:48', 0);
INSERT INTO `white_list` VALUES (31, '顾杰', '男', '1986-06-19', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (32, '侯芳', '女', '2000-05-07', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (33, '邵强', '男', '1992-10-31', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (34, '孟婷', '女', '1995-03-14', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (35, '龙斌', '男', '1988-12-09', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (36, '万莉', '女', '1999-07-26', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (37, '段伟', '男', '1991-04-18', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (38, '雷敏', '女', '1984-11-21', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (39, '钱浩', '男', '2002-02-14', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (40, '汤静', '女', '1993-08-07', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (41, '尹超', '男', '1987-01-29', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (42, '黎雪', '女', '1996-06-13', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (43, '常磊', '男', '2001-12-05', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (44, '武芳', '女', '1990-09-24', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (45, '赖杰', '男', '1985-04-16', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (46, '文丽', '女', '1998-10-09', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (47, '曾涛', '男', '1994-03-02', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (48, '白梅', '女', '1989-07-27', 1, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (49, '谭阳', '男', '2003-11-11', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 1);
INSERT INTO `white_list` VALUES (50, '廖敏', '女', '1997-05-19', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', NULL, 0);
INSERT INTO `white_list` VALUES (51, '王小伟', '男', '1990-05-15', 2, '10353feb-f256-4e87-a4ac-f3d09cc08cb6.jpg', '2025-07-23 15:57:47', '2025-07-25 17:21:27', 1);
INSERT INTO `white_list` VALUES (52, '周迎杰1', '男', '2000-01-01', 1, 'eed2dbea-2221-4d55-910f-e40b01fe64d7.png', '2025-07-28 09:53:27', '2025-07-28 11:02:29', 0);
INSERT INTO `white_list` VALUES (53, '恒智百川', '男', '2000-01-01', 1, '29d5ee1a-708b-4ce8-b78d-0aed7665ac82.png', '2025-07-28 11:07:06', NULL, 0);
COMMIT;


